Show All

Edit a macro

Before you edit a macro, you should be familiar with the Visual Basic Editor. The Visual Basic Editor can be used to write and edit macros attached to Microsoft Excel workbooks.

1. Set the security level to Medium or Low.

   How?

   1. On the Tools menu, click Options.
   2. Click the Security tab.
   3. Under Macro Security, click Macro Security.
   4. Click the Security Level tab, and then select the security level you want to use.
2. On the Tools menu, point to Macro, and then click Macros.
3. In the Macro name box, enter the name of the macro.
4. Click Edit.
5. For Help with the Visual Basic Editor, on the Help menu, click Microsoft Visual Basic Help.